Clothing sales management and order/shipping system development: Streamlining order to picking.
Thanks to the unique development, it has become possible to rearrange data according to the desired field configuration, significantly improving the picking efficiency of the shipping personnel.
■Trigger With the increase in the number of products, it became necessary to review the layout structure and printed fields of the "picking list," which is essential for shipping operations. Although we were already using business software, customization for adding or changing list items required additional licensing, prompting us to consider original development. During this process, we learned about a company that develops "Excel macros" and decided to explore the introduction of a proprietary system. ■Background of Implementation We thought that if the functionality was limited to data transfer, it could be handled using an Excel-based solution, leading us to adopt custom development using macro language. In addition to order management, due to warehouse shelving considerations, there was a request from on-site staff for "more than five patterns of packing lists," which led us to adopt Excel for report forms. Although the business software could output picking lists, it could not handle the maximum number of fields or allow for free ordering as standard features, which placed a burden on warehouse workers during shipping operations.
- Company:セルネッツ 本社
- Price:100,000 yen-500,000 yen